Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_MVIEW_KEYS

`ALL_MVIEW_KEYS` describes the columns or expressions in the `SELECT` list upon which materialized views accessible to the current user are based.

Related Views

- `DBA_MVIEW_KEYS` describes such columns and expressions for all materialized views in the database.

- `USER_MVIEW_KEYS` describes such columns and expressions for all materialized views owned by the current user.

All three views exclude materialized views that reference remote tables or that includes references to a nonstatic value such as `SYSDATE` or `USER`. These views also exclude materialized views that were created as snapshots prior to Oracle8i and that were never altered to enable query rewrite.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the materialized view
`MVIEW_NAME` | `VARCHAR2(30)` | `NOT NULL` | Materialized view name
`POSITION_IN_SELECT` | `NUMBER` | `NOT NULL` | Ordinal position of this key within the `SELECT` list
`CONTAINER_COLUMN` | `VARCHAR2(30)` | `NOT NULL` | Name of the column in the container table
`DETAILOBJ_OWNER` | `VARCHAR2(30)` | `NOT NULL` | Detail object owner
`DETAILOBJ_NAME` | `VARCHAR2(30)` | `NOT NULL` | Detail object name (for example, the name of a table or view)
`DETAILOBJ_TYPE` | `VARCHAR2(5)` |  | Detail object type (`VIEW` | `TABLE`)
`DETAILOBJ_ALIAS` | `VARCHAR2(30)` |  | Implicit or explicit alias for detail relation
`DETAILOBJ_COLUMN` | `VARCHAR2(30)` | `NOT NULL` | Name of the detail relation column